hd_task

Dataset statistics

Number of variables	9
Number of observations	52416
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.8 MiB
Average record size in memory	135.5 B

Variable types

DateTime	1
Numeric	8

Alerts

`Zone 1 Power Consumption` is highly overall correlated with `Zone 2 Power Consumption` and 1 other fields	High correlation
`Zone 2 Power Consumption` is highly overall correlated with `Zone 1 Power Consumption` and 1 other fields	High correlation
`Zone 3 Power Consumption` is highly overall correlated with `Zone 1 Power Consumption` and 1 other fields	High correlation
`diffuse flows` is highly overall correlated with `general diffuse flows`	High correlation
`general diffuse flows` is highly overall correlated with `diffuse flows`	High correlation
`DateTime` has unique values	Unique

Reproduction

Analysis started	2024-04-12 01:55:56.860769
Analysis finished	2024-04-12 01:56:05.317882
Duration	8.46 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

DateTime
Date

UNIQUE

Distinct	52416
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	409.6 KiB

Minimum	2017-01-01 00:00:00
Maximum	2017-12-30 23:50:00

Histogram

Histogram with fixed size bins (bins=50)

Temperature
Real number (ℝ)

Distinct	3437
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.810024

Minimum	3.247
Maximum	40.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	409.6 KiB

Quantile statistics

Minimum	3.247
5-th percentile	9.8
Q1	14.41
median	18.78
Q3	22.89
95-th percentile	28.39
Maximum	40.01
Range	36.763
Interquartile range (IQR)	8.48

Descriptive statistics

Standard deviation	5.8154758
Coefficient of variation (CV)	0.30916898
Kurtosis	-0.30332122
Mean	18.810024
Median Absolute Deviation (MAD)	4.26
Skewness	0.19671914
Sum	985946.22
Variance	33.819759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.18	58	0.1%
20.76	56	0.1%
19.79	55	0.1%
20.74	52	0.1%
20.83	51	0.1%
15.85	51	0.1%
15.84	51	0.1%
21	50	0.1%
20.89	50	0.1%
20.37	49	0.1%
Other values (3427)	51893	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.247	1	< 0.1%
3.441	1	< 0.1%
3.541	1	< 0.1%
3.555	1	< 0.1%
3.582	1	< 0.1%
3.629	1	< 0.1%
3.638	1	< 0.1%
3.662	1	< 0.1%
3.681	1	< 0.1%
3.706	1	< 0.1%

Value	Count	Frequency (%)
40.01	1	< 0.1%
39.78	1	< 0.1%
39.76	1	< 0.1%
39.74	1	< 0.1%
39.73	1	< 0.1%
39.7	1	< 0.1%
39.67	1	< 0.1%
39.6	1	< 0.1%
39.59	1	< 0.1%
39.55	1	< 0.1%

Humidity
Real number (ℝ)

Distinct	4443
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68.259518

Minimum	11.34
Maximum	94.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	409.6 KiB

Quantile statistics

Minimum	11.34
5-th percentile	39.45
Q1	58.31
median	69.86
Q3	81.4
95-th percentile	88.9
Maximum	94.8
Range	83.46
Interquartile range (IQR)	23.09

Descriptive statistics

Standard deviation	15.551177
Coefficient of variation (CV)	0.2278243
Kurtosis	-0.12185965
Mean	68.259518
Median Absolute Deviation (MAD)	11.54
Skewness	-0.62516601
Sum	3577890.9
Variance	241.83911
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85.9	197	0.4%
84.6	190	0.4%
85	189	0.4%
86.6	187	0.4%
86.3	186	0.4%
85.8	185	0.4%
87.2	175	0.3%
86.8	173	0.3%
87.4	171	0.3%
86.9	171	0.3%
Other values (4433)	50592	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11.34	2	< 0.1%
11.57	1	< 0.1%
11.94	1	< 0.1%
12.27	1	< 0.1%
12.3	1	< 0.1%
12.6	1	< 0.1%
12.74	1	< 0.1%
12.87	1	< 0.1%
13.04	1	< 0.1%
13.07	1	< 0.1%

Value	Count	Frequency (%)
94.8	3	< 0.1%
94.7	4	< 0.1%
94.6	1	< 0.1%
94.5	2	< 0.1%
94.4	1	< 0.1%
94.3	2	< 0.1%
94.2	4	< 0.1%
94.1	6	< 0.1%
94	9	< 0.1%
93.9	10	< 0.1%

Wind Speed
Real number (ℝ)

Distinct	548
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9594889

Minimum	0.05
Maximum	6.483
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	409.6 KiB

Quantile statistics

Minimum	0.05
5-th percentile	0.069
Q1	0.078
median	0.086
Q3	4.915
95-th percentile	4.923
Maximum	6.483
Range	6.433
Interquartile range (IQR)	4.837

Descriptive statistics

Standard deviation	2.348862
Coefficient of variation (CV)	1.1987116
Kurtosis	-1.7831692
Mean	1.9594889
Median Absolute Deviation (MAD)	0.016
Skewness	0.46242332
Sum	102708.57
Variance	5.5171525
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.082	2291	4.4%
0.083	1979	3.8%
0.084	1831	3.5%
0.081	1804	3.4%
0.085	1513	2.9%
0.08	1502	2.9%
0.073	1485	2.8%
4.919	1430	2.7%
4.916	1375	2.6%
0.072	1369	2.6%
Other values (538)	35837	68.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.05	1	< 0.1%
0.053	5	< 0.1%
0.054	10	< 0.1%
0.055	13	< 0.1%
0.056	9	< 0.1%
0.057	17	< 0.1%
0.058	4	< 0.1%
0.059	7	< 0.1%
0.06	9	< 0.1%
0.061	11	< 0.1%

Value	Count	Frequency (%)
6.483	1	< 0.1%
6.325	1	< 0.1%
6.2	1	< 0.1%
5.817	1	< 0.1%
5.69	1	< 0.1%
5.402	1	< 0.1%
5.375	1	< 0.1%
5.044	1	< 0.1%
5.019	1	< 0.1%
5.014	2	< 0.1%

general diffuse flows
Real number (ℝ)

HIGH CORRELATION

Distinct	10504
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	182.69661

Minimum	0.004
Maximum	1163
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	409.6 KiB

Quantile statistics

Minimum	0.004
5-th percentile	0.037
Q1	0.062
median	5.0355
Q3	319.6
95-th percentile	782
Maximum	1163
Range	1162.996
Interquartile range (IQR)	319.538

Descriptive statistics

Standard deviation	264.40096
Coefficient of variation (CV)	1.4472132
Kurtosis	0.40276752
Mean	182.69661
Median Absolute Deviation (MAD)	5.0095
Skewness	1.3069729
Sum	9576225.7
Variance	69907.867
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.055	1576	3.0%
0.062	1557	3.0%
0.051	1497	2.9%
0.059	1474	2.8%
0.066	1459	2.8%
0.048	1388	2.6%
0.044	1292	2.5%
0.073	1262	2.4%
0.04	1125	2.1%
0.077	1116	2.1%
Other values (10494)	38670	73.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.004	3	< 0.1%
0.007	9	< 0.1%
0.011	38	0.1%
0.015	97	0.2%
0.018	184	0.4%
0.022	309	0.6%
0.026	436	0.8%
0.029	566	1.1%
0.033	699	1.3%
0.037	924	1.8%

Value	Count	Frequency (%)
1163	1	< 0.1%
1122	1	< 0.1%
1102	1	< 0.1%
1099	1	< 0.1%
1082	1	< 0.1%
1069	1	< 0.1%
1055	1	< 0.1%
1051	1	< 0.1%
1050	1	< 0.1%
1044	1	< 0.1%

diffuse flows
Real number (ℝ)

HIGH CORRELATION

Distinct	10449
Distinct (%)	19.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75.028022

Minimum	0.011
Maximum	936
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	409.6 KiB

Quantile statistics

Minimum	0.011
5-th percentile	0.085
Q1	0.122
median	4.456
Q3	101
95-th percentile	331.85
Maximum	936
Range	935.989
Interquartile range (IQR)	100.878

Descriptive statistics

Standard deviation	124.21095
Coefficient of variation (CV)	1.6555274
Kurtosis	7.0029015
Mean	75.028022
Median Absolute Deviation (MAD)	4.393
Skewness	2.4569065
Sum	3932668.8
Variance	15428.36
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.115	1260	2.4%
0.122	1218	2.3%
0.119	1201	2.3%
0.126	1150	2.2%
0.111	1140	2.2%
0.13	1093	2.1%
0.104	1085	2.1%
0.1	963	1.8%
0.137	926	1.8%
0.096	915	1.7%
Other values (10439)	41465	79.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.011	1	< 0.1%
0.019	3	< 0.1%
0.022	2	< 0.1%
0.026	4	< 0.1%
0.03	10	< 0.1%
0.033	18	< 0.1%
0.037	20	< 0.1%
0.041	34	0.1%
0.044	53	0.1%
0.048	74	0.1%

Value	Count	Frequency (%)
936	1	< 0.1%
933	1	< 0.1%
922	2	< 0.1%
909	1	< 0.1%
903	1	< 0.1%
897	1	< 0.1%
863	1	< 0.1%
856	1	< 0.1%
855	1	< 0.1%
851	1	< 0.1%

Zone 1 Power Consumption
Real number (ℝ)

HIGH CORRELATION

Distinct	27709
Distinct (%)	52.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32344.971

Minimum	13895.696
Maximum	52204.395
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	409.6 KiB

Quantile statistics

Minimum	13895.696
5-th percentile	21867.342
Q1	26310.669
median	32265.92
Q3	37309.018
95-th percentile	44712.058
Maximum	52204.395
Range	38308.699
Interquartile range (IQR)	10998.349

Descriptive statistics

Standard deviation	7130.5626
Coefficient of variation (CV)	0.22045352
Kurtosis	-0.75405439
Mean	32344.971
Median Absolute Deviation (MAD)	5513.8039
Skewness	0.22886369
Sum	1.695394 × 10⁹
Variance	50844922
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34560	30	0.1%
23040	24	< 0.1%
28800	19	< 0.1%
25920	18	< 0.1%
23672.42196	13	< 0.1%
35441.31148	13	< 0.1%
21063.34426	12	< 0.1%
21950.76923	12	< 0.1%
31680	12	< 0.1%
22880.68085	11	< 0.1%
Other values (27699)	52252	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13895.6962	1	< 0.1%
13920	1	< 0.1%
13932.1519	1	< 0.1%
14090.12658	1	< 0.1%
14327.08861	1	< 0.1%
14557.97468	1	< 0.1%
14612.65823	1	< 0.1%
15013.67089	1	< 0.1%
15524.05063	1	< 0.1%
15572.65823	1	< 0.1%

Value	Count	Frequency (%)
52204.39512	1	< 0.1%
52146.85905	1	< 0.1%
52038.1798	1	< 0.1%
51955.07214	1	< 0.1%
51916.71476	1	< 0.1%
51820.82131	1	< 0.1%
51776.07103	1	< 0.1%
51737.71365	1	< 0.1%
51731.32075	1	< 0.1%
51718.53496	1	< 0.1%

Zone 2 Power Consumption
Real number (ℝ)

HIGH CORRELATION

Distinct	29621
Distinct (%)	56.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21042.509

Minimum	8560.0815
Maximum	37408.861
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	409.6 KiB

Quantile statistics

Minimum	8560.0815
5-th percentile	13284.146
Q1	16980.766
median	20823.168
Q3	24713.718
95-th percentile	30387.137
Maximum	37408.861
Range	28848.779
Interquartile range (IQR)	7732.9515

Descriptive statistics

Standard deviation	5201.4659
Coefficient of variation (CV)	0.24718848
Kurtosis	-0.43739724
Mean	21042.509
Median Absolute Deviation (MAD)	3867.0469
Skewness	0.32887602
Sum	1.1029642 × 10⁹
Variance	27055247
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21600	16	< 0.1%
25200	12	< 0.1%
14148.32827	11	< 0.1%
23400	11	< 0.1%
22800	11	< 0.1%
16158.83576	11	< 0.1%
13732.5228	10	< 0.1%
18000	10	< 0.1%
13539.20973	10	< 0.1%
22962.16216	10	< 0.1%
Other values (29611)	52304	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8560.081466	1	< 0.1%
8585.743381	1	< 0.1%
8633.401222	1	< 0.1%
8651.731161	1	< 0.1%
8787.372709	1	< 0.1%
8897.352342	1	< 0.1%
8912.016293	1	< 0.1%
9131.97556	1	< 0.1%
9307.942974	1	< 0.1%
9365.944272	1	< 0.1%

Value	Count	Frequency (%)
37408.86076	1	< 0.1%
36645.56962	1	< 0.1%
36482.78775	1	< 0.1%
36437.17001	1	< 0.1%
36429.56705	1	< 0.1%
36391.55227	1	< 0.1%
36353.53749	1	< 0.1%
36201.47835	1	< 0.1%
36129.25026	1	< 0.1%
36110.24287	1	< 0.1%

Zone 3 Power Consumption
Real number (ℝ)

HIGH CORRELATION

Distinct	22838
Distinct (%)	43.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17835.406

Minimum	5935.1741
Maximum	47598.326
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	409.6 KiB

Quantile statistics

Minimum	5935.1741
5-th percentile	9519.3277
Q1	13129.327
median	16415.117
Q3	21624.1
95-th percentile	29905.709
Maximum	47598.326
Range	41663.152
Interquartile range (IQR)	8494.7738

Descriptive statistics

Standard deviation	6622.1651
Coefficient of variation (CV)	0.3712932
Kurtosis	1.0863933
Mean	17835.406
Median Absolute Deviation (MAD)	3866.1593
Skewness	1.0238715
Sum	9.3486065 × 10⁸
Variance	43853071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17280	26	< 0.1%
11520	19	< 0.1%
9600	17	< 0.1%
9450.180072	17	< 0.1%
9588.47539	16	< 0.1%
9173.589436	15	< 0.1%
9795.918367	15	< 0.1%
16366.26506	15	< 0.1%
9617.286915	15	< 0.1%
9329.171669	14	< 0.1%
Other values (22828)	52247	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5935.17407	1	< 0.1%
6044.657863	1	< 0.1%
6061.944778	1	< 0.1%
6108.043217	1	< 0.1%
6119.567827	1	< 0.1%
6182.953181	1	< 0.1%
6200.240096	1	< 0.1%
6211.764706	1	< 0.1%
6223.289316	1	< 0.1%
6252.10084	1	< 0.1%

Value	Count	Frequency (%)
47598.32636	2	< 0.1%
47580.25105	1	< 0.1%
47507.94979	1	< 0.1%
47441.67364	1	< 0.1%
47435.64854	1	< 0.1%
47429.62343	1	< 0.1%
47405.52301	1	< 0.1%
47291.04603	1	< 0.1%
47278.99582	1	< 0.1%
47266.94561	1	< 0.1%

Auto

Heatmap
Table

	Humidity	Temperature	Wind Speed	Zone 1 Power Consumption	Zone 2 Power Consumption	Zone 3 Power Consumption	diffuse flows	general diffuse flows
Humidity	1.000	-0.378	-0.181	-0.300	-0.309	-0.212	-0.253	-0.459
Temperature	-0.378	1.000	0.326	0.433	0.379	0.436	0.261	0.472
Wind Speed	-0.181	0.326	1.000	0.107	0.087	0.079	0.022	0.157
Zone 1 Power Consumption	-0.300	0.433	0.107	1.000	0.851	0.748	0.125	0.261
Zone 2 Power Consumption	-0.309	0.379	0.087	0.851	1.000	0.538	0.097	0.242
Zone 3 Power Consumption	-0.212	0.436	0.079	0.748	0.538	1.000	-0.021	0.085
diffuse flows	-0.253	0.261	0.022	0.125	0.097	-0.021	1.000	0.786
general diffuse flows	-0.459	0.472	0.157	0.261	0.242	0.085	0.786	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	DateTime	Temperature	Humidity	Wind Speed	general diffuse flows	diffuse flows	Zone 1 Power Consumption	Zone 2 Power Consumption	Zone 3 Power Consumption
0	1/1/2017 0:00	6.559	73.8	0.083	0.051	0.119	34055.69620	16128.87538	20240.96386
1	1/1/2017 0:10	6.414	74.5	0.083	0.070	0.085	29814.68354	19375.07599	20131.08434
2	1/1/2017 0:20	6.313	74.5	0.080	0.062	0.100	29128.10127	19006.68693	19668.43373
3	1/1/2017 0:30	6.121	75.0	0.083	0.091	0.096	28228.86076	18361.09422	18899.27711
4	1/1/2017 0:40	5.921	75.7	0.081	0.048	0.085	27335.69620	17872.34043	18442.40964
5	1/1/2017 0:50	5.853	76.9	0.081	0.059	0.108	26624.81013	17416.41337	18130.12048
6	1/1/2017 1:00	5.641	77.7	0.080	0.048	0.096	25998.98734	16993.31307	17945.06024
7	1/1/2017 1:10	5.496	78.2	0.085	0.055	0.093	25446.07595	16661.39818	17459.27711
8	1/1/2017 1:20	5.678	78.1	0.081	0.066	0.141	24777.72152	16227.35562	17025.54217
9	1/1/2017 1:30	5.491	77.3	0.082	0.062	0.111	24279.49367	15939.20973	16794.21687

	DateTime	Temperature	Humidity	Wind Speed	general diffuse flows	diffuse flows	Zone 1 Power Consumption	Zone 2 Power Consumption	Zone 3 Power Consumption
52406	12/30/2017 22:20	7.650	70.1	0.081	0.062	0.122	34323.95437	28676.28107	15684.99400
52407	12/30/2017 22:30	7.480	71.0	0.085	0.062	0.104	33776.42586	28230.74563	15546.69868
52408	12/30/2017 22:40	7.390	71.2	0.079	0.066	0.100	33387.07224	27814.66708	15396.87875
52409	12/30/2017 22:50	7.340	71.0	0.084	0.037	0.119	32815.20913	27564.28352	15172.14886
52410	12/30/2017 23:00	7.070	72.5	0.080	0.059	0.093	32158.17490	27273.39675	14987.75510
52411	12/30/2017 23:10	7.010	72.4	0.080	0.040	0.096	31160.45627	26857.31820	14780.31212
52412	12/30/2017 23:20	6.947	72.6	0.082	0.051	0.093	30430.41825	26124.57809	14428.81152
52413	12/30/2017 23:30	6.900	72.8	0.086	0.084	0.074	29590.87452	25277.69254	13806.48259
52414	12/30/2017 23:40	6.758	73.0	0.080	0.066	0.089	28958.17490	24692.23688	13512.60504
52415	12/30/2017 23:50	6.580	74.1	0.081	0.062	0.111	28349.80989	24055.23167	13345.49820

Overview

Variables

Interactions

Correlations

Missing values

Sample